package net.hn.hnms.biz.project.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.hn.hnms.biz.project.domain.StandingBookManage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
* @author jayx
* @description 针对表【standing_book_manage】的数据库操作Mapper
* @createDate 2023-03-13 16:44:03
* @Entity generator.domain.StandingBookManage
*/
public interface StandingBookManageMapper extends BaseMapper<StandingBookManage> {

    @Update("<script>" +
            " update  standing_book_manage set  del_flag = '1' " +
            " where id in" +
            " <foreach collection=\"list\" item=\"value\" separator=\",\" open=\"(\" close=\")\">\n" +
            "#{value}" +
            "</foreach>" +
            "</script>")
    void updateDeleteByIds(@Param("list") List<String> list);

    @Update("<script>" +
            " update  project_budget set  del_flag = '1' " +
            " where project_id in" +
            " <foreach collection=\"list\" item=\"value\" separator=\",\" open=\"(\" close=\")\">\n" +
            "#{value}" +
            "</foreach>" +
            "</script>")
    void updateDeleteBudgetByIds(@Param("list") List<String> list);
}




